-- @author lixiyong01
-- @date 2024.07.09
-- host_list表

alter table hdp_lbg_supin_zplisting.raw_hism_host_list
add if not exists partition (dt='${RUNDATE}')
location 'hdfs://node101:9090/home/hdp_idea/rawdata/hism/host/raw_hism_host_list/${RUNDATE}';


alter table hdp_lbg_supin_zplisting.raw_hism_host_list
add if not exists partition (dt='20240712')
location 'hdfs://node101:9090/home/hdp_idea/rawdata/hism/host/raw_hism_host_list/20240712';


select split(content,'\u0001') as items
from hdp_lbg_supin_zplisting.raw_hism_host_list
where dt='20240712'
